[dbo].[asi_DropNameAllView]

Property	Value
ANSI Nulls On
Quoted Identifier On

SQL Script

-- =============================================
-- Author:        Paul Bradshaw
-- Create date: Jan 30th, 2007
-- Description:    Drop the Name_All View
-- =============================================
CREATE PROCEDURE asi_DropNameAllView
AS
BEGIN
    -- SET NOCOUNT ON added to prevent extra result sets from
    -- interfering with SELECT statements.
    SET NOCOUNT ON;

    IF EXISTS (SELECT 1 FROM sysobjects WHERE name = 'Name_All' AND type = 'V')
        DROP VIEW Name_All
END

GO